custom code "sum if" (SSRS2005)
Looking at my reports, I find myself constantly using this:
=Sum( IIf(Fields!fieldA.Value = "somevalue",
Fields!fieldB.Value, 0.00)
)
I was trying to implement something like
SumIf( Fields!fieldA.Value = "somevalue", Fields!fieldB.Value )
via custom code, but I don't know where to start. Is that even possible?
May 15th, 2012 4:46am
Hi Krebel,
Generally, we can achieve it with expression in SSRS:http://msdn.microsoft.com/en-us/library/ms157328.aspx
If you want to implement it with custom code, please refer:http://odetocode.com/Articles/130.aspx
http://msdn.microsoft.com/en-us/library/ms157328.aspx#CustomCode
Thanks,
LolaPlease remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 10:41pm


